﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="TestForm.aspx.vb" Inherits="TWIN_test.TestForm" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    Employee Name:<asp:TextBox ID="usernameTextBox" runat="server"></asp:TextBox>
    <asp:Button ID="getIdButton" runat="server" Text="Get Employee ID" />
    <br />
    Employee ID:<asp:SqlDataSource 
        ID="resultSQL" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" 
        
        SelectCommand="SELECT * FROM &quot;ORA_ASPNET_USERS&quot; WHERE (&quot;USERNAME&quot; = :USERNAME)">
        <SelectParameters>
            <asp:ControlParameter ControlID="usernameTextBox" Name="USERNAME" 
                PropertyName="Text" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 
        DataSourceID="resultSQL" Height="208px" Width="469px">
        <Fields>
            <asp:BoundField DataField="USERNAME" HeaderText="USERNAME" 
                SortExpression="USERNAME" />
            <asp:BoundField DataField="LOWEREDUSERNAME" HeaderText="LOWEREDUSERNAME" 
                SortExpression="LOWEREDUSERNAME" />
            <asp:BoundField DataField="MOBILEALIAS" HeaderText="MOBILEALIAS" 
                SortExpression="MOBILEALIAS" />
            <asp:BoundField DataField="ISANONYMOUS" HeaderText="ISANONYMOUS" 
                SortExpression="ISANONYMOUS" />
            <asp:BoundField DataField="LASTACTIVITYDATE" HeaderText="LASTACTIVITYDATE" 
                SortExpression="LASTACTIVITYDATE" />
        </Fields>
    </asp:DetailsView>
    <asp:FormView ID="FormView1" runat="server" DataKeyNames="USERID" 
        DataSourceID="resultSQL">
        <EditItemTemplate>
            APPLICATIONID:
            <asp:TextBox ID="APPLICATIONIDTextBox" runat="server" 
                Text='<%# Bind("APPLICATIONID") %>' />
            <br />
            USERID:
            <asp:Label ID="USERIDLabel1" runat="server" Text='<%# Eval("USERID") %>' />
            <br />
            USERNAME:
            <asp:TextBox ID="USERNAMETextBox" runat="server" 
                Text='<%# Bind("USERNAME") %>' />
            <br />
            LOWEREDUSERNAME:
            <asp:TextBox ID="LOWEREDUSERNAMETextBox" runat="server" 
                Text='<%# Bind("LOWEREDUSERNAME") %>' />
            <br />
            MOBILEALIAS:
            <asp:TextBox ID="MOBILEALIASTextBox" runat="server" 
                Text='<%# Bind("MOBILEALIAS") %>' />
            <br />
            ISANONYMOUS:
            <asp:TextBox ID="ISANONYMOUSTextBox" runat="server" 
                Text='<%# Bind("ISANONYMOUS") %>' />
            <br />
            LASTACTIVITYDATE:
            <asp:TextBox ID="LASTACTIVITYDATETextBox" runat="server" 
                Text='<%# Bind("LASTACTIVITYDATE") %>' />
            <br />
            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 
                CommandName="Update" Text="Update" />
            &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" 
                CausesValidation="False" CommandName="Cancel" Text="Cancel" />
        </EditItemTemplate>
        <InsertItemTemplate>
            APPLICATIONID:
            <asp:TextBox ID="APPLICATIONIDTextBox" runat="server" 
                Text='<%# Bind("APPLICATIONID") %>' />
            <br />
            USERID:
            <asp:TextBox ID="USERIDTextBox" runat="server" Text='<%# Bind("USERID") %>' />
            <br />
            USERNAME:
            <asp:TextBox ID="USERNAMETextBox" runat="server" 
                Text='<%# Bind("USERNAME") %>' />
            <br />
            LOWEREDUSERNAME:
            <asp:TextBox ID="LOWEREDUSERNAMETextBox" runat="server" 
                Text='<%# Bind("LOWEREDUSERNAME") %>' />
            <br />
            MOBILEALIAS:
            <asp:TextBox ID="MOBILEALIASTextBox" runat="server" 
                Text='<%# Bind("MOBILEALIAS") %>' />
            <br />
            ISANONYMOUS:
            <asp:TextBox ID="ISANONYMOUSTextBox" runat="server" 
                Text='<%# Bind("ISANONYMOUS") %>' />
            <br />
            LASTACTIVITYDATE:
            <asp:TextBox ID="LASTACTIVITYDATETextBox" runat="server" 
                Text='<%# Bind("LASTACTIVITYDATE") %>' />
            <br />
            <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                CommandName="Insert" Text="Insert" />
            &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" 
                CausesValidation="False" CommandName="Cancel" Text="Cancel" />
        </InsertItemTemplate>
        <ItemTemplate>
            APPLICATIONID:
            <asp:Label ID="APPLICATIONIDLabel" runat="server" 
                Text='<%# Bind("APPLICATIONID") %>' />
            <br />
            USERID:
            <asp:Label ID="USERIDLabel" runat="server" Text='<%# Eval("USERID") %>' />
            <br />
            USERNAME:
            <asp:Label ID="USERNAMELabel" runat="server" Text='<%# Bind("USERNAME") %>' />
            <br />
            LOWEREDUSERNAME:
            <asp:Label ID="LOWEREDUSERNAMELabel" runat="server" 
                Text='<%# Bind("LOWEREDUSERNAME") %>' />
            <br />
            MOBILEALIAS:
            <asp:Label ID="MOBILEALIASLabel" runat="server" 
                Text='<%# Bind("MOBILEALIAS") %>' />
            <br />
            ISANONYMOUS:
            <asp:Label ID="ISANONYMOUSLabel" runat="server" 
                Text='<%# Bind("ISANONYMOUS") %>' />
            <br />
            LASTACTIVITYDATE:
            <asp:Label ID="LASTACTIVITYDATELabel" runat="server" 
                Text='<%# Bind("LASTACTIVITYDATE") %>' />
            <br />

        </ItemTemplate>
    </asp:FormView>
    </form>
</body>
</html>
